Tabela DgActiveSubstanceInteraction

Definicja tabeli DgActiveSubstanceInteraction

Name

DgActiveSubstanceInteraction

Code

DgActiveSubstanceInteraction

Comment

interakcje miedzy substancjami aktywnymi


Lista kolumn tabeli DgActiveSubstanceInteraction

Name

Code

ActiveSubstanceInteractionID

ActiveSubstanceInteractionID

DrugDBTypeID

DrugDBTypeID

ActiveSubstanceID1

ActiveSubstanceID1

ActiveSubstanceID2

ActiveSubstanceID2

InteractionLevelID

InteractionLevelID

Description

Description


Kolumna ActiveSubstanceInteractionID tabeli DgActiveSubstanceInteraction

Definicja kolumny ActiveSubstanceInteractionID tabeli DgActiveSubstanceInteraction

Name

ActiveSubstanceInteractionID

Code

ActiveSubstanceInteractionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID interakcji


Kolumna DrugDBTypeID tabeli DgActiveSubstanceInteraction

Definicja kolumny DrugDBTypeID tabeli DgActiveSubstanceInteraction

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

typ bazy leków/interakcji


Kolumna ActiveSubstanceID1 tabeli DgActiveSubstanceInteraction

Definicja kolumny ActiveSubstanceID1 tabeli DgActiveSubstanceInteraction

Name

ActiveSubstanceID1

Code

ActiveSubstanceID1

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id pierwszej aktywnej substancji


Kolumna ActiveSubstanceID2 tabeli DgActiveSubstanceInteraction

Definicja kolumny ActiveSubstanceID2 tabeli DgActiveSubstanceInteraction

Name

ActiveSubstanceID2

Code

ActiveSubstanceID2

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id drugiej aktywnej substancji


Kolumna InteractionLevelID tabeli DgActiveSubstanceInteraction

Definicja kolumny InteractionLevelID tabeli DgActiveSubstanceInteraction

Name

InteractionLevelID

Code

InteractionLevelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID poziomu interakcji


Kolumna Description tabeli DgActiveSubstanceInteraction

Definicja kolumny Description tabeli DgActiveSubstanceInteraction

Name

Description

Code

Description

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Lista kluczy tabeli DgActiveSubstanceInteraction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgActiveSubstanceInteraction

Definicja klucza Identifier_1 tabeli DgActiveSubstanceInteraction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment